---
title: DB-CLL-029 — Retrieve the request issue list for a case
summary: Retrieve the request issue list for a case
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-029 — Retrieve the request issue list for a case

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-029 |
| Operation type | R |
| Execution method | Text |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Inline text SQL |
| Business object | clsRequestIssue collection ctor |
| Criteria property | MyRetrieveSQL |
| Lifecycle method | BeforeRetrieve |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| LegalCaseID | Input | NUMBER | N/A | Legal case identifier used to filter request issues |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [REQUEST_ISSUE](../database-tables.md#request_issue) | SELECT | LEGAL_CASE_SEQ_NUM, REQUEST_ISSUE_CODE, REQUEST_ISSUE_TEXT |

## Sample SQL

```sql
Select
  REQUEST_ISSUE.REQUEST_ISSUE_SEQ_NUM as RequestIssueID,
  REQUEST_ISSUE.LEGAL_CASE_SEQ_NUM as LegalCaseID,
  REQUEST_ISSUE.REQUEST_ISSUE_CODE as RequestIssueCode,
  REQUEST_ISSUE.REQUEST_ISSUE_TEXT as RequestIssueText
From
  REQUEST_ISSUE
Where
  REQUEST_ISSUE.LEGAL_CASE_SEQ_NUM = :LegalCaseID
```

## Operations and processes

- [Manage other legal parties and request issues](../operations/manage-other-legal-party-and-request-issue.md)

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsRequestIssue.vb`